Formats Excluded by Numeric Masking Facility
APPX's numeric masking facility was designed to provide maximum flexibility. You can define a mask in any format that is not specifically excluded below.
Masks must include at least one digit placeholder, and no more than 15 digit placeholders.
Each digit placeholder character, if used, must appear in the following sequence in the mask:
98*0.089.
9s, if used, must define the outside boundaries for digits in a mask. Leading 9s must be placed to the left of all other digit placeholders, and trailing 9s must be placed to the right of all other digit placeholders.
99880.08999 Correct, 98980.08998 Incorrect
8s, if used, must be placed between any 9s and the *s or 0s. Leading 8s must be placed to the right of any 9s, and to the left of any *s or 0s. Trailing 8s must be placed to the left of ant 9s, and to the right of 0s.
9,980.089 Correct, 9,890.098 Incorrect, 9,*80.089 Incorrect
*s are leading digit placeholders only. If used, they must be placed between any leading 9s or *s and any leading 0s in the mask.
0s, if used, must define the inside boundaries for digits in a mask. Leading 0s must be placed to the right of all other digit placeholders, and trailing 0s must be placed to the left of all other digit placeholders.
The only characters that can be placed between any two digit placeholders are the decimal and group characters, or another digit placeholder.
A mask can contain only one decimal, and the decimal must be followed by a digit placeholder.
A group character, if included in a mask, must be positioned to the left of any decimal and used to separate groups of three digit placeholders. For example, APPX considers an entry of 9,99 to be text rather than digit placeholders and a group character because the group character is not associated with a group of three-digit placeholders.
The paired sign indicators '( )' or '< > must be placed outside of the far right- and left-hand digit placeholders in a mask.
(99,990.009) Correct, <99,990.009> Correct, 9(9,990.009) Incorrect
Text, if entered, must be placed outside of the far right- and left-hand digit placeholders in a mask.
|